CREATE TABLE [dbo].[RoleBase]
(
[Oid] [uniqueidentifier] NOT NULL ROWGUIDCOL,
[Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OptimisticLockField] [int] NULL,
[GCRecord] [int] NULL,
[ObjectType] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RoleBase] ADD CONSTRAINT [PK_RoleBase] PRIMARY KEY CLUSTERED  ([Oid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iGCRecord_RoleBase] ON [dbo].[RoleBase] ([GCRecord]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iObjectType_RoleBase] ON [dbo].[RoleBase] ([ObjectType]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RoleBase] WITH NOCHECK ADD CONSTRAINT [FK_RoleBase_ObjectType] FOREIGN KEY ([ObjectType]) REFERENCES [dbo].[XPObjectType] ([OID]) NOT FOR REPLICATION
GO
